Skip to main content

enq: JI - contention

Short Description

Lock held during materialized view operations

Additional Information​

An enqueue is a wait for a resource held by another.

This wait is seen during materialized view operations (like refresh, alter) to prevent concurrent operations on the same materialized view. It ensures that two or more refresh processes do not try to refresh the same object.

How to reduce this wait​

Don’t refresh the same materialized view object by many sessions at the same time.

If the JI enqueue holder is an intended refresh session, the other session(s) that intend to refresh the same materialized view may just need to wait until the first one finishes.

Otherwise you might need to kill the problematic session to clear this lock.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.